Sameer Karkhanis
Sameer Karkhanis
Reactions
-
Re: Can I automatically adjust predecessor dates by changing the dependent date?
You should change the dates of the predecessor and not the task that it dependent on it. In your case change the date of "walk to pool" from 9/5/22 to 9/8/22 and rest will be automatically …2 · -
Re: How to Calculate # of years passed from start date
=ROUNDUP((TODAY()-[Start Date]@row)/365, 1) If you are not particular about months and ok with rounding off, then you can also use, =YEAR(TODAY())-YEAR([Start Date]@row)1 · -
Add function to retrieve values from cell for a multi-select column
Like the COUNTM which gives the count of values in a multi-select cell, it would be great if there is any function or combination of functions that can provide an array/list of values from a cell so …30 · -
Re: IF(OR(Find Statement
May not be the best approach but can serve the purpose, =IF(FIND("TZ", [Address]@row) > 0, LEFT([Address]@row, FIND("TZ", [Address]@row) - 1) , IF(FIND("GZ", [Address…1 · -
Reports and Dashboards break if column is renamed in a Sheet
Reports and dashboards break if the columns in the source sheet are renamed :-( It will be great if @smartsheet does not depend on the column names from the sheet when used in reports as it will then…3 ·
